Problem Note 64605: You experience performance issues with the BULKUNLOAD=YES option with SAS/ACCESS® Interface to Netezza because it incorrectly reads all observations
 |  |  |  |  |
When you use the BULKUNLOAD=YES option with SAS/ACCESS Interface to Netezza, all observations are incorrectly processed by Netezza, regardless of whether you limit the result set with the OBS=<n> SAS option.
For example, you would encounter this issue if you ran code similar to the following:
options OBS=10;
data test;
set test.NZTABLE(BULKUNLOAD=YES);
run;
The output table TEST contains the correct result set with 10 observations, but all observations in the NZTABLE in Netezza are processed with SELECT * FROM NZTABLE. This behavior adds unnecessary overhead and affects performance negatively.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Netezza | Microsoft® Windows® for x64 | 9.4 TS1M5 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2016 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 9.4 TS1M5 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 9.4 TS1M5 | 9.4 TS1M6 | ||
| HP-UX IPF | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Linux for x64 | 9.4 TS1M5 | 9.4 TS1M6 | ||
A fix for this issue for SAS/ACCESS Interface to Netezza 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F8R.html#64605A fix for this issue for SAS/ACCESS Interface to Netezza 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C9E.html#64605| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2019-08-23 09:37:55 |
| Date Created: | 2019-08-13 08:37:37 |